package com.tutu.model.dao;

/**
 * @author 图图 2020/10/11
 * 联系人的信息表
 */
public class ContactTable {
    public  static final String TAB_NAME = "tab_contact";
    // 用户名
    public static  final  String COL_USERNAME = "username";
    // 密码
    public static  final  String COL_USERPWD = "userpwd";
    // 环信ID
    public static  final  String COL_HXID = "hxid";
    // 用户昵称
    public static  final  String COL_NICK = "nick";
    // 用户头像
    public static  final String COL_PHOTO = "photo";
    // 用户手机号
    public static  final  String COL_PHONE = "phone";
    //用户邮箱
    public static  final  String COL_EMAIL = "email";
    //用户性别 0 女生 1 男生
    public static  final String COL_GENDER = "gender";
    //用户真实姓名
    public static  final String COL_REALNAME = "realname";
    // 是否是联系人 1是 0不是
    public static final String COL_IS_CONTACT = "is_contact";

    public  static final String CREATE_TAB = "create table "
            + TAB_NAME + " ("
            + COL_HXID + " text primary key,"
            + COL_USERNAME + " text,"
            + COL_USERPWD  + " text,"
            + COL_NICK     + " text,"
            + COL_PHOTO    + " text,"
            + COL_PHONE    + " text,"
            + COL_EMAIL    + " text,"
            + COL_GENDER   + " INTEGER default 1,"
            + COL_REALNAME + " text,"
            + COL_IS_CONTACT + " integer);";

}
